﻿CREATE PROCEDURE [dbo].[sp_admin_getNews]
AS
	SELECT News_Items.Item_Id, News_Items.Item_Author, News_Items.Item_Date, News_Categories.Category_Id, News_Categories.Category_Name, News_Items.Item_Headline, News_Items.Item_Body, News_Items.Item_Active
	FROM News_Items INNER JOIN News_Categories ON News_Items.Item_Category = News_Categories.Category_Id
    ORDER BY News_Items.Item_Date DESC
RETURN 0